Nevertheless The following portion I'm having difficulties to accomplish following the mass copy and paste has run I need another code that should update column A appropriately these that the Work num from sheet 2 will fill in to each in between duties 2 and 10,000 I've connected the sheet waiting for link from Social Network Posts (2)